﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Statistics" targetNamespace="http://tempuri.org/Statistics.xsd" xmlns:mstns="http://tempuri.org/Statistics.xsd" xmlns="http://tempuri.org/Statistics.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="ILEConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ILEConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.ILEConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Stats_LoginTableAdapter" GeneratorDataComponentClassName="Stats_LoginTableAdapter" Name="Stats_Login" UserDataComponentName="Stats_LoginTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillStats_Logins" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetStats_Logins" GeneratorSourceName="FillStats_Logins" GetMethodModifier="Public" GetMethodName="GetStats_Logins" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetStats_Logins" UserSourceName="FillStats_Logins">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Users_Stats_Login.StatsLoginID, Users_Stats_Login.UserID, Users_Stats_Login.LoginDateTime, Users_Stats_Login.LogoutDateTime, 
                      Users_Stats_Login.IpAddress, Users_Stats_Login.OS, Users_Stats_Login.Browser, Users.Username, Users.AccountType, Users.FirstName, 
                      Users.LastName, Users.Email, Users.StudentIDNumber, Users.IsEnabled
FROM         Users_Stats_Login INNER JOIN
                      Users ON Users_Stats_Login.UserID = Users.UserID</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="StatsLoginID" DataSetColumn="StatsLoginID" />
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="LoginDateTime" DataSetColumn="LoginDateTime" />
              <Mapping SourceColumn="LogoutDateTime" DataSetColumn="LogoutDateTime" />
              <Mapping SourceColumn="IpAddress" DataSetColumn="IpAddress" />
              <Mapping SourceColumn="OS" DataSetColumn="OS" />
              <Mapping SourceColumn="Browser" DataSetColumn="Browser" />
              <Mapping SourceColumn="Username" DataSetColumn="Username" />
              <Mapping SourceColumn="AccountType" DataSetColumn="AccountType" />
              <Mapping SourceColumn="FirstName" DataSetColumn="FirstName" />
              <Mapping SourceColumn="LastName" DataSetColumn="LastName" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="StudentIDNumber" DataSetColumn="StudentIDNumber" />
              <Mapping SourceColumn="IsEnabled" DataSetColumn="IsEnabled" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy2" GeneratorSourceName="CheckLoginFailure" Modifier="Public" Name="CheckLoginFailure" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="CheckLoginFailure">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     COUNT(Users_Stats_Login.StatsLoginID) AS Expr1
FROM         Users_Stats_Login INNER JOIN
                      Users ON Users_Stats_Login.UserID = Users.UserID
WHERE     (Users_Stats_Login.IpAddress = @IpAddress) AND (Users_Stats_Login.LoginDateTime &gt;= @LoginDateTime) AND 
                      (Users_Stats_Login.Browser = @Browser) AND (Users_Stats_Login.LogoutDateTime IS NULL)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="IpAddress" ColumnName="IpAddress" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE3 OPEN SOURCE\ILE\APP_DATA\ILE.MDF].dbo.Users_Stats_Login" DataTypeServer="varchar(40)" DbType="AnsiString" Direction="Input" ParameterName="@IpAddress" Precision="0" ProviderType="VarChar" Scale="0" Size="40" SourceColumn="IpAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="LoginDateTime" ColumnName="LoginDateTime" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE3 OPEN SOURCE\ILE\APP_DATA\ILE.MDF].dbo.Users_Stats_Login" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@LoginDateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="LoginDateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Browser" ColumnName="Browser" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE3 OPEN SOURCE\ILE\APP_DATA\ILE.MDF].dbo.Users_Stats_Login" DataTypeServer="varchar(30)" DbType="AnsiString" Direction="Input" ParameterName="@Browser" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="Browser" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillStatsLoginByAccountType" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetStatsLoginByAccountType" GeneratorSourceName="FillStatsLoginByAccountType" GetMethodModifier="Public" GetMethodName="GetStatsLoginByAccountType" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetStatsLoginByAccountType" UserSourceName="FillStatsLoginByAccountType">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Users_Stats_Login.StatsLoginID, Users_Stats_Login.UserID, Users_Stats_Login.LoginDateTime, Users_Stats_Login.LogoutDateTime, 
                      Users_Stats_Login.IpAddress, Users_Stats_Login.OS, Users_Stats_Login.Browser, Users.Username, Users.AccountType, Users.FirstName, 
                      Users.LastName, Users.Email, Users.StudentIDNumber, Users.IsEnabled
FROM         Users_Stats_Login INNER JOIN
                      Users ON Users_Stats_Login.UserID = Users.UserID
WHERE     (Users.AccountType = @AccountType)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="AccountType" ColumnName="AccountType" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="varchar(15)" DbType="AnsiString" Direction="Input" ParameterName="@AccountType" Precision="0" ProviderType="VarChar" Scale="0" Size="15" SourceColumn="AccountType" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillStatsLoginByDate" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetStatsLoginByDate" GeneratorSourceName="FillStatsLoginByDate" GetMethodModifier="Public" GetMethodName="GetStatsLoginByDate" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetStatsLoginByDate" UserSourceName="FillStatsLoginByDate">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Users_Stats_Login.StatsLoginID, Users_Stats_Login.UserID, Users_Stats_Login.LoginDateTime, Users_Stats_Login.LogoutDateTime, 
                      Users_Stats_Login.IpAddress, Users_Stats_Login.OS, Users_Stats_Login.Browser, Users.Username, Users.AccountType, Users.FirstName, 
                      Users.LastName, Users.Email, Users.StudentIDNumber, Users.IsEnabled
FROM         Users_Stats_Login INNER JOIN
                      Users ON Users_Stats_Login.UserID = Users.UserID
WHERE     (Users_Stats_Login.LoginDateTime &gt; @StartDateTime) AND (Users_Stats_Login.LoginDateTime &lt;= @EndDateTime)
ORDER BY Users_Stats_Login.StatsLoginID DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="StartDateTime" ColumnName="LoginDateTime" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Users_Stats_Login" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@StartDateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="LoginDateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="EndDateTime" ColumnName="LoginDateTime" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Users_Stats_Login" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@EndDateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="LoginDateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillStatsLoginByStatsLoginID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetStatsLoginByStatsLoginID" GeneratorSourceName="FillStatsLoginByStatsLoginID" GetMethodModifier="Public" GetMethodName="GetStatsLoginByStatsLoginID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetStatsLoginByStatsLoginID" UserSourceName="FillStatsLoginByStatsLoginID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Users_Stats_Login.StatsLoginID, Users_Stats_Login.UserID, Users_Stats_Login.LoginDateTime, Users_Stats_Login.LogoutDateTime, 
                      Users_Stats_Login.IpAddress, Users_Stats_Login.OS, Users_Stats_Login.Browser, Users.Username, Users.AccountType, Users.FirstName, 
                      Users.LastName, Users.Email, Users.StudentIDNumber, Users.IsEnabled
FROM         Users_Stats_Login INNER JOIN
                      Users ON Users_Stats_Login.UserID = Users.UserID
WHERE     (Users_Stats_Login.StatsLoginID = @StatsLoginID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="StatsLoginID" ColumnName="StatsLoginID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.Users_Stats_Login" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@StatsLoginID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="StatsLoginID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillStatsLoginByUsername" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetStatsLoginByUsername" GeneratorSourceName="FillStatsLoginByUsername" GetMethodModifier="Public" GetMethodName="GetStatsLoginByUsername" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetStatsLoginByUsername" UserSourceName="FillStatsLoginByUsername">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Users_Stats_Login.StatsLoginID, Users_Stats_Login.UserID, Users_Stats_Login.LoginDateTime, Users_Stats_Login.LogoutDateTime, 
                      Users_Stats_Login.IpAddress, Users_Stats_Login.OS, Users_Stats_Login.Browser, Users.Username, Users.AccountType, Users.FirstName, 
                      Users.LastName, Users.Email, Users.StudentIDNumber, Users.IsEnabled
FROM         Users_Stats_Login INNER JOIN
                      Users ON Users_Stats_Login.UserID = Users.UserID
WHERE Users.Username = @Username</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Username" ColumnName="Username" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Users" DataTypeServer="varchar(100)" DbType="AnsiString" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumn="Username" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="InsertStatsLogin" Modifier="Public" Name="InsertStatsLogin" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertStatsLogin">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO Users_Stats_Login
                      (UserID, LoginDateTime, IpAddress, OS, Browser)
VALUES     (@UserID,@LoginDateTime,@IpAddress,@OS,@Browser);

SELECT SCOPE_IDENTITY();</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="UserID" ColumnName="UserID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Users_Stats_Login" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="LoginDateTime" ColumnName="LoginDateTime" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Users_Stats_Login" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@LoginDateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="LoginDateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="IpAddress" ColumnName="IpAddress" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Users_Stats_Login" DataTypeServer="varchar(40)" DbType="AnsiString" Direction="Input" ParameterName="@IpAddress" Precision="0" ProviderType="VarChar" Scale="0" Size="40" SourceColumn="IpAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="OS" ColumnName="OS" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Users_Stats_Login" DataTypeServer="varchar(30)" DbType="AnsiString" Direction="Input" ParameterName="@OS" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="OS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Browser" ColumnName="Browser" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Users_Stats_Login" DataTypeServer="varchar(30)" DbType="AnsiString" Direction="Input" ParameterName="@Browser" Precision="0" ProviderType="VarChar" Scale="0" Size="30" SourceColumn="Browser" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateStatsLogin" Modifier="Public" Name="UpdateStatsLogin" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="UpdateStatsLogin">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE    Users_Stats_Login
SET              LogoutDateTime = @LogoutDateTime
WHERE     (StatsLoginID = @StatsLoginID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="LogoutDateTime" ColumnName="LogoutDateTime" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.Users_Stats_Login" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@LogoutDateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="LogoutDateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="StatsLoginID" ColumnName="StatsLoginID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\ILE\APP_DATA\ILE.MDF].dbo.Users_Stats_Login" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@StatsLoginID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="StatsLoginID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Stats_Quiz_QuestionsTableAdapter" GeneratorDataComponentClassName="Stats_Quiz_QuestionsTableAdapter" Name="Stats_Quiz_Questions" UserDataComponentName="Stats_Quiz_QuestionsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillQuizQuestions" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetQuizQuestions" GeneratorSourceName="FillQuizQuestions" GetMethodModifier="Public" GetMethodName="GetQuizQuestions" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetQuizQuestions" UserSourceName="FillQuizQuestions">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Stats_Quiz_Questions.QuizSubmissionID, Stats_Quiz_Questions.LearnObjID, Stats_Quiz_Questions.QuestionID, 
                      Stats_Quiz_Questions.IsAnsweredCorrectly, Stats_Quiz_Questions.WrongAnswer, Stats_Quiz_Questions.TimeStamp, 
                      Assignments_Submission_Quiz.AssignmentID, Assignments_Submission_Quiz.UserID, Assignments_Submission_Quiz.CourseID, 
                      Assignments_Submission_Quiz.SectionNumber, Assignments_Submission_Quiz.StandardID, Assignments_Submission_Quiz.Attempts, 
                      Users.Year
FROM         Stats_Quiz_Questions INNER JOIN
                      Assignments_Submission_Quiz ON Stats_Quiz_Questions.QuizSubmissionID = Assignments_Submission_Quiz.QuizSubmissionID INNER JOIN
                      Users ON Assignments_Submission_Quiz.UserID = Users.UserID</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="LearnObjID" DataSetColumn="LearnObjID" />
              <Mapping SourceColumn="QuestionID" DataSetColumn="QuestionID" />
              <Mapping SourceColumn="CourseID" DataSetColumn="CourseID" />
              <Mapping SourceColumn="SectionNumber" DataSetColumn="SectionNumber" />
              <Mapping SourceColumn="AssignmentID" DataSetColumn="AssignmentID" />
              <Mapping SourceColumn="StandardID" DataSetColumn="StandardID" />
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="Year" DataSetColumn="Year" />
              <Mapping SourceColumn="IsAnsweredCorrectly" DataSetColumn="IsAnsweredCorrectly" />
              <Mapping SourceColumn="WrongAnswer" DataSetColumn="WrongAnswer" />
              <Mapping SourceColumn="TimeStamp" DataSetColumn="TimeStamp" />
              <Mapping SourceColumn="QuizSubmissionID" DataSetColumn="QuizSubmissionID" />
              <Mapping SourceColumn="Attempts" DataSetColumn="Attempts" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="CountByCourseID" Modifier="Public" Name="CountByCourseID" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="CountByCourseID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     COUNT(*) AS Expr1
FROM         Stats_Quiz_Questions INNER JOIN
                      Assignments_Submission_Quiz ON Stats_Quiz_Questions.QuizSubmissionID = Assignments_Submission_Quiz.QuizSubmissionID
WHERE     (Assignments_Submission_Quiz.CourseID = @CourseID) AND (Stats_Quiz_Questions.IsAnsweredCorrectly = @IsAnsweredCorrectly)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseID" ColumnName="CourseID" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IsAnsweredCorrectly" ColumnName="IsAnsweredCorrectly" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Stats_Quiz_Questions" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsAnsweredCorrectly" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="IsAnsweredCorrectly" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="CountByCourseIdAndSectionNumber" Modifier="Public" Name="CountByCourseIdAndSectionNumber" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="CountByCourseIdAndSectionNumber">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     COUNT(*) AS Expr1
FROM         Stats_Quiz_Questions INNER JOIN
                      Assignments_Submission_Quiz ON Stats_Quiz_Questions.QuizSubmissionID = Assignments_Submission_Quiz.QuizSubmissionID
WHERE     (Assignments_Submission_Quiz.CourseID = @CourseID) AND (Assignments_Submission_Quiz.SectionNumber = @SectionNumber) AND 
                      (Stats_Quiz_Questions.IsAnsweredCorrectly = @IsAnsweredCorrectly)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseID" ColumnName="CourseID" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SectionNumber" ColumnName="SectionNumber" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IsAnsweredCorrectly" ColumnName="IsAnsweredCorrectly" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Stats_Quiz_Questions" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsAnsweredCorrectly" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="IsAnsweredCorrectly" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="CountByLearnObjID" Modifier="Public" Name="CountByLearnObjID" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="CountByLearnObjID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     COUNT(*) AS Expr1
FROM         Stats_Quiz_Questions
WHERE     (LearnObjID = @LearnObjID) AND (IsAnsweredCorrectly = @IsAnsweredCorrectly)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="LearnObjID" ColumnName="LearnObjID" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Stats_Quiz_Questions" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@LearnObjID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="LearnObjID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IsAnsweredCorrectly" ColumnName="IsAnsweredCorrectly" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Stats_Quiz_Questions" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsAnsweredCorrectly" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="IsAnsweredCorrectly" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy1" GeneratorSourceName="CountByLearnObjIdAndQuestionId" Modifier="Public" Name="CountByLearnObjIdAndQuestionId" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="CountByLearnObjIdAndQuestionId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT COUNT(*) FROM Stats_Quiz_Questions
WHERE
LearnObjID = @LearnObj AND QuestionID = @QuestionID AND IsAnsweredCorrectly = @IsAnsweredCorrectly</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="LearnObj" ColumnName="LearnObjID" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Stats_Quiz_Questions" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@LearnObj" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="LearnObjID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="QuestionID" ColumnName="QuestionID" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Stats_Quiz_Questions" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@QuestionID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="QuestionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IsAnsweredCorrectly" ColumnName="IsAnsweredCorrectly" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Stats_Quiz_Questions" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsAnsweredCorrectly" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="IsAnsweredCorrectly" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy5" GeneratorSourceName="CountByLearnObjIdAndQuestionIdAndCourseIdAndSectionNumber" Modifier="Public" Name="CountByLearnObjIdAndQuestionIdAndCourseIdAndSectionNumber" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="CountByLearnObjIdAndQuestionIdAndCourseIdAndSectionNumber">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     COUNT(*) AS Expr1
FROM         Stats_Quiz_Questions INNER JOIN
                      Assignments_Submission_Quiz ON Stats_Quiz_Questions.QuizSubmissionID = Assignments_Submission_Quiz.QuizSubmissionID INNER JOIN
                      Users ON Assignments_Submission_Quiz.UserID = Users.UserID
WHERE     (Stats_Quiz_Questions.LearnObjID = @LearnObjID) AND (Stats_Quiz_Questions.QuestionID = @QuestionID) AND 
                      (Assignments_Submission_Quiz.CourseID = @CourseID) AND (Assignments_Submission_Quiz.SectionNumber = @SectionNumber) AND 
                      (Stats_Quiz_Questions.IsAnsweredCorrectly = @IsAnsweredCorrectly)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="LearnObjID" ColumnName="LearnObjID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Stats_Quiz_Questions" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@LearnObjID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="LearnObjID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="QuestionID" ColumnName="QuestionID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Stats_Quiz_Questions" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@QuestionID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="QuestionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseID" ColumnName="CourseID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SectionNumber" ColumnName="SectionNumber" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Assignments_Submission_Quiz" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IsAnsweredCorrectly" ColumnName="IsAnsweredCorrectly" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE RC1\APP_DATA\ILE.MDF].dbo.Stats_Quiz_Questions" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsAnsweredCorrectly" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="IsAnsweredCorrectly" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="Insert1" Modifier="Public" Name="Insert1" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy5" UserSourceName="Insert1">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO Stats_Quiz_Questions
                      (QuizSubmissionID, LearnObjID, QuestionID, IsAnsweredCorrectly, WrongAnswer, TimeStamp)
VALUES     (@QuizSubmissionID,@LearnObjID,@QuestionID,@IsAnsweredCorrectly,@WrongAnswer,@TimeStamp)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="QuizSubmissionID" ColumnName="QuizSubmissionID" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Stats_Quiz_Questions" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@QuizSubmissionID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="QuizSubmissionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="LearnObjID" ColumnName="LearnObjID" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Stats_Quiz_Questions" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@LearnObjID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="LearnObjID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="QuestionID" ColumnName="QuestionID" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Stats_Quiz_Questions" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@QuestionID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="QuestionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IsAnsweredCorrectly" ColumnName="IsAnsweredCorrectly" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Stats_Quiz_Questions" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsAnsweredCorrectly" Precision="0" ProviderType="Bit" Scale="0" Size="1" SourceColumn="IsAnsweredCorrectly" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="WrongAnswer" ColumnName="WrongAnswer" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Stats_Quiz_Questions" DataTypeServer="text" DbType="AnsiString" Direction="Input" ParameterName="@WrongAnswer" Precision="0" ProviderType="Text" Scale="0" Size="2147483647" SourceColumn="WrongAnswer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="TimeStamp" ColumnName="TimeStamp" DataSourceName="[E:\WORKSPACE\ILE RC1\APP_DATA\ILE.MDF].dbo.Stats_Quiz_Questions" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@TimeStamp" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="TimeStamp" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Stats_LearnObjsTableAdapter" GeneratorDataComponentClassName="Stats_LearnObjsTableAdapter" Name="Stats_LearnObjs" UserDataComponentName="Stats_LearnObjsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.Stats_LearnObjs" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillLearnObjsStats" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetLearnObjsStats" GeneratorSourceName="FillLearnObjsStats" GetMethodModifier="Public" GetMethodName="GetLearnObjsStats" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetLearnObjsStats" UserSourceName="FillLearnObjsStats">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Stats_LearnObjs] ([LearnObjID], [UserID], [CourseID], [SectionNumber], [StandardID], [ViewDateTime], [ClickedDateTime]) VALUES (@LearnObjID, @UserID, @CourseID, @SectionNumber, @StandardID, @ViewDateTime, @ClickedDateTime)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LearnObjID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LearnObjID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StandardID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StandardID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ViewDateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ViewDateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ClickedDateTime" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ClickedDateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Stats_LearnObjs.*
FROM         Stats_LearnObjs</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="LearnObjID" DataSetColumn="LearnObjID" />
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="CourseID" DataSetColumn="CourseID" />
              <Mapping SourceColumn="SectionNumber" DataSetColumn="SectionNumber" />
              <Mapping SourceColumn="StandardID" DataSetColumn="StandardID" />
              <Mapping SourceColumn="ViewDateTime" DataSetColumn="ViewDateTime" />
              <Mapping SourceColumn="ClickedDateTime" DataSetColumn="ClickedDateTime" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="CountUniqueNumberOfStudentWentThroughLearnObj" Modifier="Public" Name="CountUniqueNumberOfStudentWentThroughLearnObj" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="CountUniqueNumberOfStudentWentThroughLearnObj">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     COUNT(DISTINCT UserID) AS Expr1
FROM         Stats_LearnObjs
WHERE     (CourseID = @CourseID) AND (SectionNumber = @SectionNumber) AND (StandardID = @StandardID) AND (LearnObjID = @LearnObjID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseID" ColumnName="CourseID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE3 OPEN SOURCE\ILE\APP_DATA\ILE.MDF].dbo.Stats_LearnObjs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SectionNumber" ColumnName="SectionNumber" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE3 OPEN SOURCE\ILE\APP_DATA\ILE.MDF].dbo.Stats_LearnObjs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="StandardID" ColumnName="StandardID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE3 OPEN SOURCE\ILE\APP_DATA\ILE.MDF].dbo.Stats_LearnObjs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@StandardID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="StandardID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="LearnObjID" ColumnName="LearnObjID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE3 OPEN SOURCE\ILE\APP_DATA\ILE.MDF].dbo.Stats_LearnObjs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@LearnObjID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="LearnObjID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.Stats_LearnObjs" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillLearnObjsStatsByCourseIdAndSectionNumber" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetLearnObjsStatsByCourseIdAndSectionNumber" GeneratorSourceName="FillLearnObjsStatsByCourseIdAndSectionNumber" GetMethodModifier="Public" GetMethodName="GetLearnObjsStatsByCourseIdAndSectionNumber" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetLearnObjsStatsByCourseIdAndSectionNumber" UserSourceName="FillLearnObjsStatsByCourseIdAndSectionNumber">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     LearnObjID, UserID, CourseID, SectionNumber, StandardID, ViewDateTime, ClickedDateTime
FROM         Stats_LearnObjs
WHERE     (CourseID = @CourseID) AND (SectionNumber = @SectionNumber)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseID" ColumnName="CourseID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE3 OPEN SOURCE\ILE\APP_DATA\ILE.MDF].dbo.Stats_LearnObjs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SectionNumber" ColumnName="SectionNumber" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE3 OPEN SOURCE\ILE\APP_DATA\ILE.MDF].dbo.Stats_LearnObjs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.Stats_LearnObjs" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillLearnObjsStatsByCourseIdAndSectionNumberAndStandardId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetLearnObjsStatsByCourseIdandSectionNumberAndStandardId" GeneratorSourceName="FillLearnObjsStatsByCourseIdAndSectionNumberAndStandardId" GetMethodModifier="Public" GetMethodName="GetLearnObjsStatsByCourseIdandSectionNumberAndStandardId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetLearnObjsStatsByCourseIdandSectionNumberAndStandardId" UserSourceName="FillLearnObjsStatsByCourseIdAndSectionNumberAndStandardId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     LearnObjID, UserID, CourseID, SectionNumber, StandardID, ViewDateTime, ClickedDateTime
FROM         Stats_LearnObjs
WHERE     (CourseID = @CourseID) AND (SectionNumber = @SectionNumber) AND (StandardID = @StandardID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseID" ColumnName="CourseID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE3 OPEN SOURCE\ILE\APP_DATA\ILE.MDF].dbo.Stats_LearnObjs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SectionNumber" ColumnName="SectionNumber" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE3 OPEN SOURCE\ILE\APP_DATA\ILE.MDF].dbo.Stats_LearnObjs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="StandardID" ColumnName="StandardID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE3 OPEN SOURCE\ILE\APP_DATA\ILE.MDF].dbo.Stats_LearnObjs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@StandardID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="StandardID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectName="dbo.Stats_LearnObjs" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillLearnObjsStatsByCourseIdAndSectionNumberAndStandardIdAndLearnObjId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetLearnObjsStatsByCourseIdAndSectionNumberAndStandardIdAndLearnObjId" GeneratorSourceName="FillLearnObjsStatsByCourseIdAndSectionNumberAndStandardIdAndLearnObjId" GetMethodModifier="Public" GetMethodName="GetLearnObjsStatsByCourseIdAndSectionNumberAndStandardIdAndLearnObjId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetLearnObjsStatsByCourseIdAndSectionNumberAndStandardIdAndLearnObjId" UserSourceName="FillLearnObjsStatsByCourseIdAndSectionNumberAndStandardIdAndLearnObjId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Stats_LearnObjs.*
FROM         Stats_LearnObjs
WHERE CourseID = @CourseID AND SectionNumber = @SectionNumber AND StandardID = @StandardID
AND LearnObjID = @LearnObjID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseID" ColumnName="CourseID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE3 OPEN SOURCE\ILE\APP_DATA\ILE.MDF].dbo.Stats_LearnObjs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SectionNumber" ColumnName="SectionNumber" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE3 OPEN SOURCE\ILE\APP_DATA\ILE.MDF].dbo.Stats_LearnObjs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="StandardID" ColumnName="StandardID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE3 OPEN SOURCE\ILE\APP_DATA\ILE.MDF].dbo.Stats_LearnObjs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@StandardID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="StandardID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="LearnObjID" ColumnName="LearnObjID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE3 OPEN SOURCE\ILE\APP_DATA\ILE.MDF].dbo.Stats_LearnObjs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@LearnObjID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="LearnObjID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Stats_LearnObjsUsersTableAdapter" GeneratorDataComponentClassName="Stats_LearnObjsUsersTableAdapter" Name="Stats_LearnObjsUsers" UserDataComponentName="Stats_LearnObjsUsersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillLearnObjsUserStats" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetLearnObjsUserStats" GeneratorSourceName="FillLearnObjsUserStats" GetMethodModifier="Public" GetMethodName="GetLearnObjsUserStats" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetLearnObjsUserStats" UserSourceName="FillLearnObjsUserStats">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Stats_LearnObjs.*, Users.Username, Users.FirstName, Users.LastName
FROM         Stats_LearnObjs INNER JOIN
                      Users ON Stats_LearnObjs.UserID = Users.UserID</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="LearnObjID" DataSetColumn="LearnObjID" />
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="CourseID" DataSetColumn="CourseID" />
              <Mapping SourceColumn="SectionNumber" DataSetColumn="SectionNumber" />
              <Mapping SourceColumn="StandardID" DataSetColumn="StandardID" />
              <Mapping SourceColumn="ViewDateTime" DataSetColumn="ViewDateTime" />
              <Mapping SourceColumn="ClickedDateTime" DataSetColumn="ClickedDateTime" />
              <Mapping SourceColumn="Username" DataSetColumn="Username" />
              <Mapping SourceColumn="FirstName" DataSetColumn="FirstName" />
              <Mapping SourceColumn="LastName" DataSetColumn="LastName" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ILEConnectionString (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillLearnObjStat" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetLearnOBjStat" GeneratorSourceName="FillLearnObjStat" GetMethodModifier="Public" GetMethodName="GetLearnOBjStat" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetLearnOBjStat" UserSourceName="FillLearnObjStat">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT     Stats_LearnObjs.LearnObjID, Stats_LearnObjs.UserID, Stats_LearnObjs.CourseID, Stats_LearnObjs.SectionNumber, Stats_LearnObjs.StandardID, 
                      Stats_LearnObjs.ViewDateTime, Stats_LearnObjs.ClickedDateTime, Users.Username, Users.FirstName, Users.LastName
FROM         Stats_LearnObjs INNER JOIN
                      Users ON Stats_LearnObjs.UserID = Users.UserID
WHERE     (Stats_LearnObjs.LearnObjID = @LearnObjID) AND (Stats_LearnObjs.CourseID = @CourseID) AND 
                      (Stats_LearnObjs.SectionNumber = @SectionNumber) AND (Stats_LearnObjs.StandardID = @StandardID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="LearnObjID" ColumnName="LearnObjID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE3 OPEN SOURCE\ILE\APP_DATA\ILE.MDF].dbo.Stats_LearnObjs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@LearnObjID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="LearnObjID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="CourseID" ColumnName="CourseID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE3 OPEN SOURCE\ILE\APP_DATA\ILE.MDF].dbo.Stats_LearnObjs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SectionNumber" ColumnName="SectionNumber" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE3 OPEN SOURCE\ILE\APP_DATA\ILE.MDF].dbo.Stats_LearnObjs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SectionNumber" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SectionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="StandardID" ColumnName="StandardID" DataSourceName="[C:\DOCUMENTS AND SETTINGS\JEINDUS\DESKTOP\ILE3 OPEN SOURCE\ILE\APP_DATA\ILE.MDF].dbo.Stats_LearnObjs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@StandardID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="StandardID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Statistics" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="Statistics" msprop:Generator_DataSetName="Statistics">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Stats_Login" msprop:Generator_UserTableName="Stats_Login" msprop:Generator_RowDeletedName="Stats_LoginRowDeleted" msprop:Generator_RowChangedName="Stats_LoginRowChanged" msprop:Generator_RowClassName="Stats_LoginRow" msprop:Generator_RowChangingName="Stats_LoginRowChanging" msprop:Generator_RowEvArgName="Stats_LoginRowChangeEvent" msprop:Generator_RowEvHandlerName="Stats_LoginRowChangeEventHandler" msprop:Generator_TableClassName="Stats_LoginDataTable" msprop:Generator_TableVarName="tableStats_Login" msprop:Generator_RowDeletingName="Stats_LoginRowDeleting" msprop:Generator_TablePropName="Stats_Login">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="StatsLoginID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="StatsLoginID" msprop:Generator_ColumnPropNameInRow="StatsLoginID" msprop:Generator_ColumnVarNameInTable="columnStatsLoginID" msprop:Generator_ColumnPropNameInTable="StatsLoginIDColumn" type="xs:int" />
              <xs:element name="UserID" msprop:Generator_UserColumnName="UserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" type="xs:int" />
              <xs:element name="LoginDateTime" msprop:Generator_UserColumnName="LoginDateTime" msprop:Generator_ColumnPropNameInRow="LoginDateTime" msprop:Generator_ColumnVarNameInTable="columnLoginDateTime" msprop:Generator_ColumnPropNameInTable="LoginDateTimeColumn" type="xs:dateTime" />
              <xs:element name="LogoutDateTime" msprop:Generator_UserColumnName="LogoutDateTime" msprop:Generator_ColumnPropNameInRow="LogoutDateTime" msprop:Generator_ColumnVarNameInTable="columnLogoutDateTime" msprop:Generator_ColumnPropNameInTable="LogoutDateTimeColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="IpAddress" msprop:Generator_UserColumnName="IpAddress" msprop:Generator_ColumnPropNameInRow="IpAddress" msprop:Generator_ColumnVarNameInTable="columnIpAddress" msprop:Generator_ColumnPropNameInTable="IpAddressColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OS" msprop:Generator_UserColumnName="OS" msprop:Generator_ColumnPropNameInRow="OS" msprop:Generator_ColumnVarNameInTable="columnOS" msprop:Generator_ColumnPropNameInTable="OSColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Browser" msprop:Generator_UserColumnName="Browser" msprop:Generator_ColumnPropNameInRow="Browser" msprop:Generator_ColumnVarNameInTable="columnBrowser" msprop:Generator_ColumnPropNameInTable="BrowserColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Username" msprop:Generator_UserColumnName="Username" msprop:Generator_ColumnPropNameInRow="Username" msprop:Generator_ColumnVarNameInTable="columnUsername" msprop:Generator_ColumnPropNameInTable="UsernameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AccountType" msprop:Generator_UserColumnName="AccountType" msprop:Generator_ColumnPropNameInRow="AccountType" msprop:Generator_ColumnVarNameInTable="columnAccountType" msprop:Generator_ColumnPropNameInTable="AccountTypeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FirstName" msprop:Generator_UserColumnName="FirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastName" msprop:Generator_UserColumnName="LastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_UserColumnName="Email" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInTable="EmailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StudentIDNumber" msprop:Generator_UserColumnName="StudentIDNumber" msprop:Generator_ColumnPropNameInRow="StudentIDNumber" msprop:Generator_ColumnVarNameInTable="columnStudentIDNumber" msprop:Generator_ColumnPropNameInTable="StudentIDNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsEnabled" msprop:Generator_UserColumnName="IsEnabled" msprop:Generator_ColumnPropNameInRow="IsEnabled" msprop:Generator_ColumnVarNameInTable="columnIsEnabled" msprop:Generator_ColumnPropNameInTable="IsEnabledColumn" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Stats_Quiz_Questions" msprop:Generator_UserTableName="Stats_Quiz_Questions" msprop:Generator_RowDeletedName="Stats_Quiz_QuestionsRowDeleted" msprop:Generator_RowChangedName="Stats_Quiz_QuestionsRowChanged" msprop:Generator_RowClassName="Stats_Quiz_QuestionsRow" msprop:Generator_RowChangingName="Stats_Quiz_QuestionsRowChanging" msprop:Generator_RowEvArgName="Stats_Quiz_QuestionsRowChangeEvent" msprop:Generator_RowEvHandlerName="Stats_Quiz_QuestionsRowChangeEventHandler" msprop:Generator_TableClassName="Stats_Quiz_QuestionsDataTable" msprop:Generator_TableVarName="tableStats_Quiz_Questions" msprop:Generator_RowDeletingName="Stats_Quiz_QuestionsRowDeleting" msprop:Generator_TablePropName="Stats_Quiz_Questions">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="LearnObjID" msprop:Generator_UserColumnName="LearnObjID" msprop:Generator_ColumnVarNameInTable="columnLearnObjID" msprop:Generator_ColumnPropNameInRow="LearnObjID" msprop:Generator_ColumnPropNameInTable="LearnObjIDColumn" type="xs:int" />
              <xs:element name="QuestionID" msprop:Generator_UserColumnName="QuestionID" msprop:Generator_ColumnVarNameInTable="columnQuestionID" msprop:Generator_ColumnPropNameInRow="QuestionID" msprop:Generator_ColumnPropNameInTable="QuestionIDColumn" type="xs:int" />
              <xs:element name="CourseID" msprop:Generator_UserColumnName="CourseID" msprop:Generator_ColumnVarNameInTable="columnCourseID" msprop:Generator_ColumnPropNameInRow="CourseID" msprop:Generator_ColumnPropNameInTable="CourseIDColumn" type="xs:int" />
              <xs:element name="SectionNumber" msprop:Generator_UserColumnName="SectionNumber" msprop:Generator_ColumnVarNameInTable="columnSectionNumber" msprop:Generator_ColumnPropNameInRow="SectionNumber" msprop:Generator_ColumnPropNameInTable="SectionNumberColumn" type="xs:int" />
              <xs:element name="AssignmentID" msprop:Generator_UserColumnName="AssignmentID" msprop:Generator_ColumnVarNameInTable="columnAssignmentID" msprop:Generator_ColumnPropNameInRow="AssignmentID" msprop:Generator_ColumnPropNameInTable="AssignmentIDColumn" type="xs:int" />
              <xs:element name="StandardID" msprop:Generator_UserColumnName="StandardID" msprop:Generator_ColumnVarNameInTable="columnStandardID" msprop:Generator_ColumnPropNameInRow="StandardID" msprop:Generator_ColumnPropNameInTable="StandardIDColumn" type="xs:int" />
              <xs:element name="UserID" msprop:Generator_UserColumnName="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" type="xs:int" />
              <xs:element name="Year" msprop:Generator_UserColumnName="Year" msprop:Generator_ColumnVarNameInTable="columnYear" msprop:Generator_ColumnPropNameInRow="Year" msprop:Generator_ColumnPropNameInTable="YearColumn" type="xs:int" minOccurs="0" />
              <xs:element name="IsAnsweredCorrectly" msprop:Generator_UserColumnName="IsAnsweredCorrectly" msprop:Generator_ColumnVarNameInTable="columnIsAnsweredCorrectly" msprop:Generator_ColumnPropNameInRow="IsAnsweredCorrectly" msprop:Generator_ColumnPropNameInTable="IsAnsweredCorrectlyColumn" type="xs:boolean" />
              <xs:element name="WrongAnswer" msprop:Generator_UserColumnName="WrongAnswer" msprop:Generator_ColumnVarNameInTable="columnWrongAnswer" msprop:Generator_ColumnPropNameInRow="WrongAnswer" msprop:Generator_ColumnPropNameInTable="WrongAnswerColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TimeStamp" msprop:Generator_UserColumnName="TimeStamp" msprop:Generator_ColumnVarNameInTable="columnTimeStamp" msprop:Generator_ColumnPropNameInRow="TimeStamp" msprop:Generator_ColumnPropNameInTable="TimeStampColumn" type="xs:dateTime" />
              <xs:element name="QuizSubmissionID" msprop:Generator_UserColumnName="QuizSubmissionID" msprop:Generator_ColumnPropNameInRow="QuizSubmissionID" msprop:Generator_ColumnVarNameInTable="columnQuizSubmissionID" msprop:Generator_ColumnPropNameInTable="QuizSubmissionIDColumn" type="xs:int" />
              <xs:element name="Attempts" msprop:Generator_UserColumnName="Attempts" msprop:Generator_ColumnPropNameInRow="Attempts" msprop:Generator_ColumnVarNameInTable="columnAttempts" msprop:Generator_ColumnPropNameInTable="AttemptsColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Stats_LearnObjs" msprop:Generator_UserTableName="Stats_LearnObjs" msprop:Generator_RowDeletedName="Stats_LearnObjsRowDeleted" msprop:Generator_RowChangedName="Stats_LearnObjsRowChanged" msprop:Generator_RowClassName="Stats_LearnObjsRow" msprop:Generator_RowChangingName="Stats_LearnObjsRowChanging" msprop:Generator_RowEvArgName="Stats_LearnObjsRowChangeEvent" msprop:Generator_RowEvHandlerName="Stats_LearnObjsRowChangeEventHandler" msprop:Generator_TableClassName="Stats_LearnObjsDataTable" msprop:Generator_TableVarName="tableStats_LearnObjs" msprop:Generator_RowDeletingName="Stats_LearnObjsRowDeleting" msprop:Generator_TablePropName="Stats_LearnObjs">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="LearnObjID" msprop:Generator_UserColumnName="LearnObjID" msprop:Generator_ColumnVarNameInTable="columnLearnObjID" msprop:Generator_ColumnPropNameInRow="LearnObjID" msprop:Generator_ColumnPropNameInTable="LearnObjIDColumn" type="xs:int" />
              <xs:element name="UserID" msprop:Generator_UserColumnName="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" type="xs:int" />
              <xs:element name="CourseID" msprop:Generator_UserColumnName="CourseID" msprop:Generator_ColumnVarNameInTable="columnCourseID" msprop:Generator_ColumnPropNameInRow="CourseID" msprop:Generator_ColumnPropNameInTable="CourseIDColumn" type="xs:int" />
              <xs:element name="SectionNumber" msprop:Generator_UserColumnName="SectionNumber" msprop:Generator_ColumnVarNameInTable="columnSectionNumber" msprop:Generator_ColumnPropNameInRow="SectionNumber" msprop:Generator_ColumnPropNameInTable="SectionNumberColumn" type="xs:int" />
              <xs:element name="StandardID" msprop:Generator_UserColumnName="StandardID" msprop:Generator_ColumnVarNameInTable="columnStandardID" msprop:Generator_ColumnPropNameInRow="StandardID" msprop:Generator_ColumnPropNameInTable="StandardIDColumn" type="xs:int" />
              <xs:element name="ViewDateTime" msprop:Generator_UserColumnName="ViewDateTime" msprop:Generator_ColumnVarNameInTable="columnViewDateTime" msprop:Generator_ColumnPropNameInRow="ViewDateTime" msprop:Generator_ColumnPropNameInTable="ViewDateTimeColumn" type="xs:dateTime" />
              <xs:element name="ClickedDateTime" msprop:Generator_UserColumnName="ClickedDateTime" msprop:Generator_ColumnVarNameInTable="columnClickedDateTime" msprop:Generator_ColumnPropNameInRow="ClickedDateTime" msprop:Generator_ColumnPropNameInTable="ClickedDateTimeColumn" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Stats_LearnObjsUsers" msprop:Generator_UserTableName="Stats_LearnObjsUsers" msprop:Generator_RowDeletedName="Stats_LearnObjsUsersRowDeleted" msprop:Generator_RowChangedName="Stats_LearnObjsUsersRowChanged" msprop:Generator_RowClassName="Stats_LearnObjsUsersRow" msprop:Generator_RowChangingName="Stats_LearnObjsUsersRowChanging" msprop:Generator_RowEvArgName="Stats_LearnObjsUsersRowChangeEvent" msprop:Generator_RowEvHandlerName="Stats_LearnObjsUsersRowChangeEventHandler" msprop:Generator_TableClassName="Stats_LearnObjsUsersDataTable" msprop:Generator_TableVarName="tableStats_LearnObjsUsers" msprop:Generator_RowDeletingName="Stats_LearnObjsUsersRowDeleting" msprop:Generator_TablePropName="Stats_LearnObjsUsers">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="LearnObjID" msprop:Generator_UserColumnName="LearnObjID" msprop:Generator_ColumnVarNameInTable="columnLearnObjID" msprop:Generator_ColumnPropNameInRow="LearnObjID" msprop:Generator_ColumnPropNameInTable="LearnObjIDColumn" type="xs:int" />
              <xs:element name="UserID" msprop:Generator_UserColumnName="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" type="xs:int" />
              <xs:element name="CourseID" msprop:Generator_UserColumnName="CourseID" msprop:Generator_ColumnVarNameInTable="columnCourseID" msprop:Generator_ColumnPropNameInRow="CourseID" msprop:Generator_ColumnPropNameInTable="CourseIDColumn" type="xs:int" />
              <xs:element name="SectionNumber" msprop:Generator_UserColumnName="SectionNumber" msprop:Generator_ColumnVarNameInTable="columnSectionNumber" msprop:Generator_ColumnPropNameInRow="SectionNumber" msprop:Generator_ColumnPropNameInTable="SectionNumberColumn" type="xs:int" />
              <xs:element name="StandardID" msprop:Generator_UserColumnName="StandardID" msprop:Generator_ColumnVarNameInTable="columnStandardID" msprop:Generator_ColumnPropNameInRow="StandardID" msprop:Generator_ColumnPropNameInTable="StandardIDColumn" type="xs:int" />
              <xs:element name="ViewDateTime" msprop:Generator_UserColumnName="ViewDateTime" msprop:Generator_ColumnVarNameInTable="columnViewDateTime" msprop:Generator_ColumnPropNameInRow="ViewDateTime" msprop:Generator_ColumnPropNameInTable="ViewDateTimeColumn" type="xs:dateTime" />
              <xs:element name="ClickedDateTime" msprop:Generator_UserColumnName="ClickedDateTime" msprop:Generator_ColumnVarNameInTable="columnClickedDateTime" msprop:Generator_ColumnPropNameInRow="ClickedDateTime" msprop:Generator_ColumnPropNameInTable="ClickedDateTimeColumn" type="xs:dateTime" />
              <xs:element name="Username" msprop:Generator_UserColumnName="Username" msprop:Generator_ColumnVarNameInTable="columnUsername" msprop:Generator_ColumnPropNameInRow="Username" msprop:Generator_ColumnPropNameInTable="UsernameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FirstName" msprop:Generator_UserColumnName="FirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastName" msprop:Generator_UserColumnName="LastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Stats_Login" />
      <xs:field xpath="mstns:StatsLoginID" />
    </xs:unique>
    <xs:unique name="Stats_Quiz_Questions_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Stats_Quiz_Questions" />
      <xs:field xpath="mstns:QuizSubmissionID" />
      <xs:field xpath="mstns:LearnObjID" />
      <xs:field xpath="mstns:QuestionID" />
    </xs:unique>
  </xs:element>
</xs:schema>